﻿CREATE proc thuan_qtdanhmucnhomnguoidungthem    
@DienGiai nvarchar(255) ,
@DoUuTien int   
as    
if exists(select * from DanhMuc_NhomNguoiDung   Where TenNhomUser =@DienGiai)    
begin    
select ErrCode=0    
end    
else    
begin    
insert into DanhMuc_NhomNguoiDung   (TenNhomUser,DoUuTien)values(@DienGiai,@DoUuTien)    
select ErrCode=1    
end    